object UnityEmirListesiF: TUnityEmirListesiF
  Left = 266
  Top = 106
  Width = 947
  Height = 569
  Caption = 'Unity '#220'retim Emirleri Listesi'
  Color = clBtnFace
  Font.Charset = TURKISH_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'Arial'
  Font.Style = []
  KeyPreview = True
  OldCreateOrder = False
  Position = poDefaultPosOnly
  OnClose = FormClose
  OnKeyDown = FormKeyDown
  OnKeyPress = FormKeyPress
  OnShow = FormShow
  PixelsPerInch = 96
  TextHeight = 14
  object Panel1: TPanel
    Left = 0
    Top = 0
    Width = 939
    Height = 40
    Align = alTop
    BevelOuter = bvNone
    TabOrder = 0
    object Label3: TLabel
      Left = 8
      Top = 11
      Width = 34
      Height = 14
      Caption = 'Filitre 1'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clBlack
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
      Transparent = True
    end
    object lcTur: TwwDBLookupCombo
      Left = 45
      Top = 8
      Width = 172
      Height = 22
      Font.Charset = TURKISH_CHARSET
      Font.Color = clBlack
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      DisableThemes = False
      DropDownAlignment = taLeftJustify
      Selected.Strings = (
        'Baslik'#9'20'#9'Baslik'#9'F')
      LookupTable = adoTur
      LookupField = 'Ref'
      Style = csDropDownList
      Color = clWhite
      Navigator = False
      ParentFont = False
      TabOrder = 0
      AutoDropDown = True
      ShowButton = True
      UseTFields = False
      AllowClearKey = True
      ShowMatchText = True
      OnChange = blisteleClick
    end
  end
  object Panel2: TPanel
    Left = 0
    Top = 503
    Width = 939
    Height = 39
    Align = alBottom
    BevelOuter = bvNone
    TabOrder = 1
    DesignSize = (
      939
      39)
    object blistele: TBitBtn
      Left = 8
      Top = 8
      Width = 97
      Height = 25
      Caption = 'Liste Yenile'
      TabOrder = 0
      OnClick = blisteleClick
    end
    object bkapat: TBitBtn
      Left = 833
      Top = 8
      Width = 97
      Height = 25
      Anchors = [akTop, akRight]
      Caption = 'Kapat'
      TabOrder = 1
      OnClick = bkapatClick
    end
    object buretimeaktar: TButton
      Left = 112
      Top = 8
      Width = 103
      Height = 25
      Caption = #220'retime Aktar - F1'
      TabOrder = 2
      OnClick = buretimeaktarClick
    end
    object BitBtn1: TBitBtn
      Left = 699
      Top = 9
      Width = 126
      Height = 25
      Anchors = [akTop, akRight]
      Caption = #220'retim Listesini Yazd'#305'r'
      TabOrder = 3
      OnClick = BitBtn1Click
    end
    object BitBtn2: TBitBtn
      Left = 240
      Top = 8
      Width = 94
      Height = 25
      Caption = 'Ekran'#305' Yazd'#305'r'
      TabOrder = 4
      OnClick = BitBtn2Click
    end
    object bstokaemirver: TBitBtn
      Left = 351
      Top = 8
      Width = 112
      Height = 25
      Caption = 'Stok'#39'a Emir Ver - F2'
      TabOrder = 5
      OnClick = bstokaemirverClick
    end
  end
  object cxGrid1: TcxGrid
    Left = 0
    Top = 40
    Width = 939
    Height = 463
    Align = alClient
    PopupMenu = PopupMenu1
    TabOrder = 2
    object Grid1DBTableView1: TcxGridDBTableView
      OnDblClick = Grid1DBTableView1DblClick
      OnKeyPress = Grid1DBTableView1KeyPress
      NavigatorButtons.ConfirmDelete = False
      OnCustomDrawCell = Grid1DBTableView1CustomDrawCell
      DataController.DataSource = EmirListesiS
      DataController.Filter.Options = [fcoCaseInsensitive]
      DataController.Options = [dcoAnsiSort, dcoCaseInsensitive, dcoAssignGroupingValues, dcoAssignMasterDetailKeys, dcoSaveExpanding, dcoSortByDisplayText, dcoImmediatePost]
      DataController.Summary.DefaultGroupSummaryItems = <>
      DataController.Summary.FooterSummaryItems = <>
      DataController.Summary.SummaryGroups = <>
      FilterRow.InfoText = '  '
      FilterRow.Visible = True
      FilterRow.ApplyChanges = fracImmediately
      OptionsBehavior.GoToNextCellOnEnter = True
      OptionsData.CancelOnExit = False
      OptionsData.Deleting = False
      OptionsData.DeletingConfirmation = False
      OptionsData.Editing = False
      OptionsData.Inserting = False
      OptionsView.NoDataToDisplayInfoText = '  '
      OptionsView.GridLineColor = clMaroon
      OptionsView.GroupByBox = False
      OptionsView.Indicator = True
      Styles.ContentOdd = dm.cxStyle15
      Styles.Selection = dm.cxStyle14
      object Grid1DBTableView1oda: TcxGridDBColumn
        Caption = 'Oda'
        DataBinding.FieldName = 'oda'
        PropertiesClassName = 'TcxImageComboBoxProperties'
        Properties.Items = <
          item
            Description = 'Normal'
            ImageIndex = 0
            Value = '1'
          end
          item
            Description = 'Standart D'#305#351#305
            Value = '2'
          end>
        Width = 62
      end
      object Grid1DBTableView1stokkodu: TcxGridDBColumn
        Caption = 'Stokkodu'
        DataBinding.FieldName = 'stokkodu'
        Width = 133
      end
      object Grid1DBTableView1anastokkodu: TcxGridDBColumn
        Caption = 'Ana Stokkodu'
        DataBinding.FieldName = 'anastokkodu'
        Width = 122
      end
      object Grid1DBTableView1Barebone: TcxGridDBColumn
        Caption = 'Model'
        DataBinding.FieldName = 'Barebone'
        SortIndex = 0
        SortOrder = soAscending
        Width = 141
      end
      object Grid1DBTableView1adet: TcxGridDBColumn
        Caption = 'Adet'
        DataBinding.FieldName = 'adet'
        Width = 53
      end
      object Grid1DBTableView1isletimsistemikodu: TcxGridDBColumn
        Caption = #304#351'letim Sistemi'
        DataBinding.FieldName = 'isletimsistemikodu'
        Width = 125
      end
      object Grid1DBTableView1KarmaKoliKodu: TcxGridDBColumn
        Caption = 'Karma Koli'
        DataBinding.FieldName = 'KarmaKoliKodu'
        Width = 88
      end
      object Grid1DBTableView1aciklama: TcxGridDBColumn
        Caption = 'A'#231#305'klama'
        DataBinding.FieldName = 'aciklama'
        Width = 136
      end
      object Grid1DBTableView1FormNo: TcxGridDBColumn
        Caption = 'Form No'
        DataBinding.FieldName = 'FormNo'
      end
    end
    object Grid1Level1: TcxGridLevel
      GridView = Grid1DBTableView1
    end
  end
  object EmirListesi: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    Parameters = <
      item
        Name = 'UstGrupId1'
        DataType = ftString
        Size = 10
        Value = Null
      end
      item
        Name = 'GrupId1'
        DataType = ftString
        Size = 10
        Value = Null
      end
      item
        Name = 'ModelId1'
        DataType = ftString
        Size = 10
        Value = Null
      end
      item
        Name = 'UstGrupId2'
        DataType = ftString
        Size = 10
        Value = Null
      end
      item
        Name = 'GrupId2'
        DataType = ftString
        Size = 10
        Value = Null
      end
      item
        Name = 'ModelId2'
        DataType = ftString
        Size = 10
        Value = Null
      end>
    SQL.Strings = (
      'select null as id,null as siparisharid,1 as oda,stokkod,'
      
        '       stokkodu=(select stokkodu from stok where stok.stokkod=Un' +
        'ity_Emirlistesi.stokkod),sum(adet) as adet,'
      '       isletimsistemikod,'
      
        '       isletimsistemikodu=(case When (select isnull(isletimsiste' +
        'mi,0) from stok where stok.stokkod=Unity_Emirlistesi.stokkod)<>0' +
        ' then (select  Stokkodu from stok where Stokkod= (select  isnull' +
        '(isletimsistemi,0) from stok where stok.stokkod=Unity_Emirlistes' +
        'i.stokkod))  when  isletimsistemikod=0 then '#39'Lisans'#305'z'#39' else (sel' +
        'ect stokkodu from stok where stok.stokkod=Unity_EmirListesi.isle' +
        'timsistemikod) end), '
      '       KarmaKoliKod,'
      
        '       KarmaKoliKodu=(case KarmaKoliKod when 0 then '#39'Karma Kolis' +
        'iz'#39' else (select stokkodu from stok where stok.stokkod=Unity_Emi' +
        'rListesi. KarmaKoliKod) end), '
      
        '       KarmaKoliCinsi=(case KarmaKoliKod when 0 then '#39'Karma Koli' +
        'siz'#39' else (select Cinsi from stok where stok.stokkod=Unity_EmirL' +
        'istesi. KarmaKoliKod) end), '
      
        '       isletimkod=(select isnull(isletimsistemi,0) from stok whe' +
        're stok.stokkod=Unity_Emirlistesi.stokkod),'
      
        '       isletimkodu=(select  Stokkodu from stok where Stokkod= (s' +
        'elect  isnull(isletimsistemi,0) from stok where stok.stokkod=Uni' +
        'ty_Emirlistesi.stokkod)),'
      '       null as aciklama,'
      '       null as geciciuremriid,'
      '       grupkodu,'
      
        '       anastokkodu=(select Stokkodu from stok where stokkod=(sel' +
        'ect AnaStokkod from stok where stokkod=Unity_Emirlistesi.stokkod' +
        ')) ,'
      
        '       Barebone=(Case When (select UstGrupId from stok where sto' +
        'k.stokkod=Unity_Emirlistesi.stokkod)=1 then'
      
        #9#9#9#9#9'(Select Top 1 Stokkodu From Recetehar Where 10=(Select Grup' +
        'Id From Stok Where Stokkod=recetehar.Stokkod) and receteid=(Sele' +
        'ct Top 1 id From Recete Where Stokkodu=(select stokkodu from sto' +
        'k where stok.stokkod=Unity_Emirlistesi.stokkod)))'
      #9#9#9#9#9'Else'
      
        #9#9#9#9#9'(Select Top 1 Stokkodu From Recetehar Where 6=(Select GrupI' +
        'd From Stok Where Stokkod=recetehar.Stokkod) and receteid=(Selec' +
        't Top 1 id From Recete Where Stokkodu=(select stokkodu from stok' +
        ' where stok.stokkod=Unity_Emirlistesi.stokkod)))'
      #9#9#9#9#9'End)'
      ',FormNo=0'
      'from Unity_Emirlistesi'
      
        'where oda=1 and aktarilanuremrino is null and stokkod in (select' +
        ' stokkod from stok where stok.UstGrupId like :UstGrupId1 and sto' +
        'k.GrupId like :GrupId1 and stok.ModelId like :ModelId1)'
      'group by stokkod,isletimsistemikod,grupkodu, KarmaKoliKod'
      'union'
      
        'select id,siparisharid,oda,stokkod,stokkodu=(select stokkodu fro' +
        'm stok where stok.stokkod=Unity_Emirlistesi.stokkod),adet,'
      '       isletimsistemikod,'
      
        '       isletimsistemikodu=(case When (select isnull(isletimsiste' +
        'mi,0) from stok where stok.stokkod=Unity_Emirlistesi.stokkod)<>0' +
        ' then (select  Stokkodu from stok where Stokkod= (select  isnull' +
        '(isletimsistemi,0) from stok where stok.stokkod=Unity_Emirlistes' +
        'i.stokkod))  when  isletimsistemikod=0 then '#39'Lisans'#305'z'#39' else (sel' +
        'ect stokkodu from stok where stok.stokkod=Unity_EmirListesi.isle' +
        'timsistemikod) end), '
      '       KarmaKoliKod,'
      
        '       KarmaKoliKodu=(case KarmaKoliKod when 0 then '#39'Karma Kolis' +
        'iz'#39' else (select stokkodu from stok where stok.stokkod=Unity_Emi' +
        'rListesi. KarmaKoliKod) end), '
      
        '       KarmaKoliCinsi=(case KarmaKoliKod when 0 then '#39'Karma Koli' +
        'siz'#39' else (select Cinsi from stok where stok.stokkod=Unity_EmirL' +
        'istesi. KarmaKoliKod) end), '
      
        '       isletimkod=(select isnull(isletimsistemi,0) from stok whe' +
        're stok.stokkod=Unity_Emirlistesi.stokkod),'
      
        '       isletimkodu=(select  Stokkodu from stok where Stokkod= (s' +
        'elect isnull(isletimsistemi,0) from stok where stok.stokkod=Unit' +
        'y_Emirlistesi.stokkod)),'
      '       aciklama,geciciuremriid,null as grupkodu,'
      
        '       anastokkodu=(select Stokkodu from stok where stokkod=(sel' +
        'ect AnaStokkod from stok where stokkod=Unity_Emirlistesi.stokkod' +
        ')) ,'
      
        '       Barebone=(Case When (select UstGrupId from stok where sto' +
        'k.stokkod=Unity_Emirlistesi.stokkod)=1 then'
      
        #9#9#9#9#9'(Select Top 1 Stokkodu From Recetehar Where 10=(Select Grup' +
        'Id From Stok Where Stokkod=recetehar.Stokkod) and receteid=(Sele' +
        'ct Top 1 id From Recete Where Stokkodu=(select stokkodu from sto' +
        'k where stok.stokkod=Unity_Emirlistesi.stokkod)))'
      #9#9#9#9#9'Else'
      
        #9#9#9#9#9'(Select Top 1 Stokkodu From Recetehar Where 6=(Select GrupI' +
        'd From Stok Where Stokkod=recetehar.Stokkod) and receteid=(Selec' +
        't Top 1 id From Recete Where Stokkodu=(select stokkodu from stok' +
        ' where stok.stokkod=Unity_Emirlistesi.stokkod)))'
      #9#9#9#9#9'End)'
      
        ',FormNo=(Select FormNo From Gecici_UrEmri where Emirno=geciciure' +
        'mriid)'#9#9#9#9
      ' from Unity_Emirlistesi'
      
        'where oda=2 and aktarilanuremrino is null and stokkod in (select' +
        ' stokkod from stok where  stok.UstGrupId like :UstGrupId2 and st' +
        'ok.GrupId like :GrupId2 and stok.ModelId like :ModelId2)'
      '')
    Left = 32
    Top = 133
  end
  object EmirListesiS: TDataSource
    DataSet = EmirListesi
    Left = 88
    Top = 152
  end
  object PopupMenu1: TPopupMenu
    Left = 200
    Top = 200
    object retimeAktar1: TMenuItem
      Caption = #220'retime Aktar'
      OnClick = retimeAktar1Click
    end
    object SiparileriGster1: TMenuItem
      Caption = 'Sipari'#351'leri G'#246'ster'
      OnClick = SiparileriGster1Click
    end
  end
  object ReceteAdiBul: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    Parameters = <
      item
        Name = 'stokkod'
        Attributes = [paSigned]
        DataType = ftInteger
        Precision = 10
        Size = 4
        Value = Null
      end>
    SQL.Strings = (
      
        'select receteid,stokkodu=(select stokkodu from stok where stok.s' +
        'tokkod=recetehar.stokkod) from recetehar where receteid is not n' +
        'ull and urunck='#39'C'#39'  and stokkod=:stokkod')
    Left = 199
    Top = 112
  end
  object ListeyeEkle: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select * from Unity_Liste where id =0')
    Left = 200
    Top = 152
  end
  object ListeAl: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    Parameters = <
      item
        Name = 'UstGrupId1'
        DataType = ftString
        Size = 10
        Value = Null
      end
      item
        Name = 'GrupId1'
        DataType = ftString
        Size = 10
        Value = Null
      end
      item
        Name = 'ModelId1'
        DataType = ftString
        Size = 10
        Value = Null
      end>
    SQL.Strings = (
      'select id,Uremri.emirno,stokkodu,cinsi,miktar,aciklama,'
      
        '       isletimsistemi=(case when isnull(isletimsistemsiz,'#39#39')='#39#39' ' +
        'then (select top 1 (select  top 1 stokkodu from stok where stok.' +
        'stokkod=Uremrihar.stokkod) from uremrihar where uremrihar.emirno' +
        '=Uremri.emirno and (select marka from stok where stok.stokkod=Ur' +
        'emrihar.stokkod) in (219,839)) else '#39'Lisanss'#305'z'#39' end),'
      
        '      depo=(select depoadi from depolar where id=Uremri.ciktidep' +
        'o)   '
      'from Unity_Liste,Uremri'
      'where (yazdirildi is null) and Uremri.emirno=Unity_Liste.emirno'
      
        'and Exists(select stokkod from stok where Stokkodu=Uremri.Stokko' +
        'du and stok.UstGrupId like :UstGrupId1 and stok.GrupId like :Gru' +
        'pId1 and stok.ModelId like :ModelId1)'
      'order by Uremri.emirno'
      '')
    Left = 88
    Top = 232
  end
  object ListeAlS: TDataSource
    DataSet = ListeAl
    Left = 40
    Top = 232
  end
  object ppDBPipeline1: TppDBPipeline
    DataSource = ListeAlS
    AutoCreateFields = False
    UserName = 'DBPipeline1'
    Left = 256
    Top = 256
  end
  object ppListeAl: TppReport
    AutoStop = False
    DataPipeline = ppDBPipeline1
    PassSetting = psTwoPass
    PrinterSetup.BinName = 'Default'
    PrinterSetup.DocumentName = 'Report'
    PrinterSetup.PaperName = 'A4'
    PrinterSetup.PrinterName = 'Default'
    PrinterSetup.mmMarginBottom = 1000
    PrinterSetup.mmMarginLeft = 1000
    PrinterSetup.mmMarginRight = 1000
    PrinterSetup.mmMarginTop = 1000
    PrinterSetup.mmPaperHeight = 297000
    PrinterSetup.mmPaperWidth = 210000
    PrinterSetup.PaperSize = 9
    Units = utMillimeters
    AllowPrintToFile = True
    DeviceType = 'Screen'
    EmailSettings.ReportFormat = 'PDF'
    OnPreviewFormClose = ppListeAlPreviewFormClose
    OnPrintDialogCreate = ppListeAlPrintDialogCreate
    OutlineSettings.CreateNode = False
    OutlineSettings.CreatePageNodes = False
    OutlineSettings.Enabled = False
    OutlineSettings.Visible = False
    PreviewFormSettings.WindowState = wsMaximized
    PreviewFormSettings.ZoomSetting = zs100Percent
    TextSearchSettings.DefaultString = '<FindText>'
    TextSearchSettings.Enabled = True
    Left = 288
    Top = 256
    Version = '10.02'
    mmColumnWidth = 0
    DataPipelineName = 'ppDBPipeline1'
    object ppTitleBand1: TppTitleBand
      mmBottomOffset = 0
      mmHeight = 9260
      mmPrintPosition = 0
      object ppLabel1: TppLabel
        UserName = 'Label1'
        AutoSize = False
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = #220'RET'#304'M EM'#304'RLER'#304' L'#304'STES'#304
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'TIMES NEW ROMAN'
        Font.Size = 12
        Font.Style = [fsBold]
        TextAlignment = taCentered
        Transparent = True
        mmHeight = 5027
        mmLeft = 37835
        mmTop = 3440
        mmWidth = 114036
        BandType = 1
      end
      object ppSystemVariable3: TppSystemVariable
        UserName = 'SystemVariable3'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'TIMES NEW ROMAN'
        Font.Size = 8
        Font.Style = [fsBold]
        TextAlignment = taRightJustified
        Transparent = True
        mmHeight = 4233
        mmLeft = 177536
        mmTop = 4233
        mmWidth = 15610
        BandType = 1
      end
      object ppLabel8: TppLabel
        UserName = 'Label8'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'TAR'#304'H :'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'TIMES NEW ROMAN'
        Font.Size = 8
        Font.Style = [fsBold]
        TextAlignment = taRightJustified
        Transparent = True
        mmHeight = 4233
        mmLeft = 159544
        mmTop = 4233
        mmWidth = 17780
        BandType = 1
      end
      object ppLabel4: TppLabel
        UserName = 'Label4'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'L'#304'STE NO :'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'TIMES NEW ROMAN'
        Font.Size = 8
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 3528
        mmLeft = 4763
        mmTop = 4233
        mmWidth = 15610
        BandType = 1
      end
      object ppListeNo: TppLabel
        UserName = 'ListeNo'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = '1'
        Font.Charset = TURKISH_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 8
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 3704
        mmLeft = 20902
        mmTop = 4233
        mmWidth = 1852
        BandType = 1
      end
    end
    object ppHeaderBand1: TppHeaderBand
      mmBottomOffset = 0
      mmHeight = 6615
      mmPrintPosition = 0
      object ppLabel2: TppLabel
        UserName = 'Label2'
        AutoSize = False
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Emir No'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'TIMES NEW ROMAN'
        Font.Size = 10
        Font.Style = [fsBold]
        TextAlignment = taRightJustified
        Transparent = True
        mmHeight = 4233
        mmLeft = 6085
        mmTop = 1588
        mmWidth = 11906
        BandType = 0
      end
      object ppLabel3: TppLabel
        UserName = 'Label3'
        AutoSize = False
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Model'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'TIMES NEW ROMAN'
        Font.Size = 10
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 4233
        mmLeft = 19844
        mmTop = 1588
        mmWidth = 29369
        BandType = 0
      end
      object ppLabel5: TppLabel
        UserName = 'Label5'
        AutoSize = False
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Adet'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'TIMES NEW ROMAN'
        Font.Size = 10
        Font.Style = [fsBold]
        TextAlignment = taCentered
        Transparent = True
        mmHeight = 4233
        mmLeft = 50271
        mmTop = 1588
        mmWidth = 7144
        BandType = 0
      end
      object ppLabel6: TppLabel
        UserName = 'Label6'
        AutoSize = False
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = #214'zel Not/Tak'#305'lacak Par'#231'a'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'TIMES NEW ROMAN'
        Font.Size = 10
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 4233
        mmLeft = 106892
        mmTop = 1588
        mmWidth = 97896
        BandType = 0
      end
      object ppLabel7: TppLabel
        UserName = 'Label7'
        AutoSize = False
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = #304#351'letim Sistemi'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'TIMES NEW ROMAN'
        Font.Size = 10
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 4233
        mmLeft = 59267
        mmTop = 1588
        mmWidth = 44715
        BandType = 0
      end
      object ppLine1: TppLine
        UserName = 'Line1'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Weight = 0.750000000000000000
        mmHeight = 529
        mmLeft = 529
        mmTop = 6086
        mmWidth = 204788
        BandType = 0
      end
      object ppLine11: TppLine
        UserName = 'Line11'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Position = lpLeft
        Weight = 0.750000000000000000
        mmHeight = 5556
        mmLeft = 529
        mmTop = 1058
        mmWidth = 1588
        BandType = 0
      end
      object ppLine12: TppLine
        UserName = 'Line12'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Position = lpLeft
        Weight = 0.750000000000000000
        mmHeight = 5556
        mmLeft = 18521
        mmTop = 1058
        mmWidth = 1588
        BandType = 0
      end
      object ppLine14: TppLine
        UserName = 'Line14'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Position = lpLeft
        Weight = 0.750000000000000000
        mmHeight = 5556
        mmLeft = 49477
        mmTop = 1058
        mmWidth = 1588
        BandType = 0
      end
      object ppLine15: TppLine
        UserName = 'Line15'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Position = lpLeft
        Weight = 0.750000000000000000
        mmHeight = 5556
        mmLeft = 106098
        mmTop = 1058
        mmWidth = 2910
        BandType = 0
      end
      object ppLine16: TppLine
        UserName = 'Line16'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Position = lpLeft
        Weight = 0.750000000000000000
        mmHeight = 5556
        mmLeft = 205052
        mmTop = 1058
        mmWidth = 2117
        BandType = 0
      end
      object ppLine17: TppLine
        UserName = 'Line17'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Position = lpLeft
        Weight = 0.750000000000000000
        mmHeight = 5556
        mmLeft = 58208
        mmTop = 1058
        mmWidth = 1588
        BandType = 0
      end
      object ppLine18: TppLine
        UserName = 'Line18'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Weight = 0.750000000000000000
        mmHeight = 529
        mmLeft = 529
        mmTop = 794
        mmWidth = 204788
        BandType = 0
      end
    end
    object ppDetailBand1: TppDetailBand
      mmBottomOffset = 0
      mmHeight = 5821
      mmPrintPosition = 0
      object pp1: TppDBText
        UserName = 'DBText3'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'emirno'
        DataPipeline = ppDBPipeline1
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 8
        Font.Style = []
        TextAlignment = taRightJustified
        Transparent = True
        DataPipelineName = 'ppDBPipeline1'
        mmHeight = 4233
        mmLeft = 5821
        mmTop = 794
        mmWidth = 11906
        BandType = 4
      end
      object pp2: TppDBText
        UserName = 'DBText1'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'stokkodu'
        DataPipeline = ppDBPipeline1
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppDBPipeline1'
        mmHeight = 4233
        mmLeft = 19844
        mmTop = 529
        mmWidth = 29104
        BandType = 4
      end
      object pp3: TppDBText
        UserName = 'DBText2'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'miktar'
        DataPipeline = ppDBPipeline1
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 8
        Font.Style = []
        TextAlignment = taCentered
        Transparent = True
        DataPipelineName = 'ppDBPipeline1'
        mmHeight = 4233
        mmLeft = 50271
        mmTop = 529
        mmWidth = 7408
        BandType = 4
      end
      object pp5: TppDBText
        UserName = 'DBText6'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'aciklama'
        DataPipeline = ppDBPipeline1
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppDBPipeline1'
        mmHeight = 4233
        mmLeft = 106892
        mmTop = 529
        mmWidth = 97367
        BandType = 4
      end
      object pp4: TppDBText
        UserName = 'DBText4'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'isletimsistemi'
        DataPipeline = ppDBPipeline1
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppDBPipeline1'
        mmHeight = 4233
        mmLeft = 59002
        mmTop = 529
        mmWidth = 47096
        BandType = 4
      end
      object ppLine3: TppLine
        UserName = 'Line3'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Weight = 0.750000000000000000
        mmHeight = 529
        mmLeft = 529
        mmTop = 5556
        mmWidth = 204788
        BandType = 4
      end
      object ppLine4: TppLine
        UserName = 'Line4'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Position = lpLeft
        Weight = 0.750000000000000000
        mmHeight = 5556
        mmLeft = 18521
        mmTop = 0
        mmWidth = 1588
        BandType = 4
      end
      object ppLine5: TppLine
        UserName = 'Line5'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Position = lpLeft
        Weight = 0.750000000000000000
        mmHeight = 5556
        mmLeft = 49477
        mmTop = 0
        mmWidth = 1588
        BandType = 4
      end
      object ppLine6: TppLine
        UserName = 'Line6'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Position = lpLeft
        Weight = 0.750000000000000000
        mmHeight = 5556
        mmLeft = 106098
        mmTop = 0
        mmWidth = 2910
        BandType = 4
      end
      object ppLine7: TppLine
        UserName = 'Line7'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Position = lpLeft
        Weight = 0.750000000000000000
        mmHeight = 5556
        mmLeft = 58208
        mmTop = 0
        mmWidth = 1588
        BandType = 4
      end
      object ppLine8: TppLine
        UserName = 'Line8'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Position = lpLeft
        Weight = 0.750000000000000000
        mmHeight = 5556
        mmLeft = 529
        mmTop = 0
        mmWidth = 1588
        BandType = 4
      end
      object ppLine9: TppLine
        UserName = 'Line9'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Position = lpLeft
        Weight = 0.750000000000000000
        mmHeight = 5556
        mmLeft = 205052
        mmTop = 0
        mmWidth = 2117
        BandType = 4
      end
    end
    object ppFooterBand1: TppFooterBand
      mmBottomOffset = 0
      mmHeight = 11906
      mmPrintPosition = 0
      object ppSystemVariable2: TppSystemVariable
        UserName = 'SystemVariable2'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        VarType = vtPageSet
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'TIMES NEW ROMAN'
        Font.Size = 9
        Font.Style = []
        TextAlignment = taRightJustified
        Transparent = True
        mmHeight = 3704
        mmLeft = 196850
        mmTop = 794
        mmWidth = 7514
        BandType = 8
      end
      object ppLabel9: TppLabel
        UserName = 'Label9'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Mesaj       :'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'TIMES NEW ROMAN'
        Font.Size = 9
        Font.Style = [fsBold, fsUnderline]
        Transparent = True
        mmHeight = 4233
        mmLeft = 4763
        mmTop = 1588
        mmWidth = 33020
        BandType = 8
      end
    end
    object ppSummaryBand1: TppSummaryBand
      PrintHeight = phDynamic
      mmBottomOffset = 0
      mmHeight = 13758
      mmPrintPosition = 0
      object ppSubReport1: TppSubReport
        UserName = 'SubReport1'
        ExpandAll = False
        NewPrintJob = False
        OutlineSettings.CreateNode = True
        TraverseAllData = False
        DataPipelineName = 'ppDBPipeline2'
        mmHeight = 5027
        mmLeft = 0
        mmTop = 0
        mmWidth = 208000
        BandType = 7
        mmBottomOffset = 0
        mmOverFlowOffset = 0
        mmStopPosition = 0
        object ppChildReport1: TppChildReport
          AutoStop = False
          DataPipeline = ppDBPipeline2
          PrinterSetup.BinName = 'Default'
          PrinterSetup.DocumentName = 'Report'
          PrinterSetup.PaperName = 'A4'
          PrinterSetup.PrinterName = 'Default'
          PrinterSetup.mmMarginBottom = 1000
          PrinterSetup.mmMarginLeft = 1000
          PrinterSetup.mmMarginRight = 1000
          PrinterSetup.mmMarginTop = 1000
          PrinterSetup.mmPaperHeight = 297000
          PrinterSetup.mmPaperWidth = 210000
          PrinterSetup.PaperSize = 9
          Units = utMillimeters
          Version = '10.02'
          mmColumnWidth = 0
          DataPipelineName = 'ppDBPipeline2'
          object ppTitleBand3: TppTitleBand
            mmBottomOffset = 0
            mmHeight = 6350
            mmPrintPosition = 0
            object ppLabel19: TppLabel
              UserName = 'Label19'
              Border.BorderPositions = []
              Border.Color = clBlack
              Border.Style = psSolid
              Border.Visible = False
              Border.Weight = 1.000000000000000000
              Caption = #304#351'letim Sistemi'
              Font.Charset = DEFAULT_CHARSET
              Font.Color = clBlack
              Font.Name = 'Arial'
              Font.Size = 10
              Font.Style = []
              Transparent = True
              mmHeight = 3969
              mmLeft = 1588
              mmTop = 1058
              mmWidth = 22754
              BandType = 1
            end
            object ppLabel20: TppLabel
              UserName = 'Label20'
              Border.BorderPositions = []
              Border.Color = clBlack
              Border.Style = psSolid
              Border.Visible = False
              Border.Weight = 1.000000000000000000
              Caption = 'Adet'
              Font.Charset = DEFAULT_CHARSET
              Font.Color = clBlack
              Font.Name = 'Arial'
              Font.Size = 10
              Font.Style = []
              Transparent = True
              mmHeight = 3969
              mmLeft = 43656
              mmTop = 1058
              mmWidth = 7144
              BandType = 1
            end
            object ppLine21: TppLine
              UserName = 'Line21'
              Border.BorderPositions = []
              Border.Color = clBlack
              Border.Style = psSolid
              Border.Visible = False
              Border.Weight = 1.000000000000000000
              Weight = 0.750000000000000000
              mmHeight = 529
              mmLeft = 529
              mmTop = 5556
              mmWidth = 59267
              BandType = 1
            end
          end
          object ppDetailBand3: TppDetailBand
            mmBottomOffset = 0
            mmHeight = 5027
            mmPrintPosition = 0
            object ppDBText5: TppDBText
              UserName = 'DBText5'
              Border.BorderPositions = []
              Border.Color = clBlack
              Border.Style = psSolid
              Border.Visible = False
              Border.Weight = 1.000000000000000000
              DataField = 'isletimsistemi'
              DataPipeline = ppDBPipeline2
              Font.Charset = DEFAULT_CHARSET
              Font.Color = clBlack
              Font.Name = 'Arial'
              Font.Size = 10
              Font.Style = []
              ParentDataPipeline = False
              Transparent = True
              DataPipelineName = 'ppDBPipeline2'
              mmHeight = 3969
              mmLeft = 1588
              mmTop = 529
              mmWidth = 36513
              BandType = 4
            end
            object ppDBText6: TppDBText
              UserName = 'DBText1'
              Border.BorderPositions = []
              Border.Color = clBlack
              Border.Style = psSolid
              Border.Visible = False
              Border.Weight = 1.000000000000000000
              DataField = 'miktar'
              DataPipeline = ppDBPipeline2
              Font.Charset = DEFAULT_CHARSET
              Font.Color = clBlack
              Font.Name = 'Arial'
              Font.Size = 10
              Font.Style = []
              ParentDataPipeline = False
              Transparent = True
              DataPipelineName = 'ppDBPipeline2'
              mmHeight = 3969
              mmLeft = 43656
              mmTop = 529
              mmWidth = 17198
              BandType = 4
            end
          end
        end
      end
      object ppSubReport4: TppSubReport
        UserName = 'SubReport4'
        ExpandAll = False
        NewPrintJob = False
        OutlineSettings.CreateNode = True
        TraverseAllData = False
        DataPipelineName = 'ppDBPipeline4'
        mmHeight = 5027
        mmLeft = 0
        mmTop = 7673
        mmWidth = 208000
        BandType = 7
        mmBottomOffset = 0
        mmOverFlowOffset = 0
        mmStopPosition = 0
        object ppChildReport4: TppChildReport
          AutoStop = False
          DataPipeline = ppDBPipeline4
          PrinterSetup.BinName = 'Default'
          PrinterSetup.DocumentName = 'Report'
          PrinterSetup.PaperName = 'A4'
          PrinterSetup.PrinterName = 'Default'
          PrinterSetup.mmMarginBottom = 1000
          PrinterSetup.mmMarginLeft = 1000
          PrinterSetup.mmMarginRight = 1000
          PrinterSetup.mmMarginTop = 1000
          PrinterSetup.mmPaperHeight = 297000
          PrinterSetup.mmPaperWidth = 210000
          PrinterSetup.PaperSize = 9
          Units = utMillimeters
          Version = '10.02'
          mmColumnWidth = 0
          DataPipelineName = 'ppDBPipeline4'
          object ppTitleBand5: TppTitleBand
            mmBottomOffset = 0
            mmHeight = 6615
            mmPrintPosition = 0
            object ppLabel24: TppLabel
              UserName = 'Label24'
              Border.BorderPositions = []
              Border.Color = clBlack
              Border.Style = psSolid
              Border.Visible = False
              Border.Weight = 1.000000000000000000
              Caption = 'Karma Koli'
              Font.Charset = DEFAULT_CHARSET
              Font.Color = clBlack
              Font.Name = 'Arial'
              Font.Size = 10
              Font.Style = []
              Transparent = True
              mmHeight = 3969
              mmLeft = 135732
              mmTop = 1058
              mmWidth = 17198
              BandType = 1
            end
            object ppLine13: TppLine
              UserName = 'Line13'
              Border.BorderPositions = []
              Border.Color = clBlack
              Border.Style = psSolid
              Border.Visible = False
              Border.Weight = 1.000000000000000000
              Weight = 0.750000000000000000
              mmHeight = 529
              mmLeft = 134938
              mmTop = 5556
              mmWidth = 59267
              BandType = 1
            end
            object ppLabel25: TppLabel
              UserName = 'Label202'
              Border.BorderPositions = []
              Border.Color = clBlack
              Border.Style = psSolid
              Border.Visible = False
              Border.Weight = 1.000000000000000000
              Caption = 'Adet'
              Font.Charset = DEFAULT_CHARSET
              Font.Color = clBlack
              Font.Name = 'Arial'
              Font.Size = 10
              Font.Style = []
              Transparent = True
              mmHeight = 3969
              mmLeft = 177800
              mmTop = 1058
              mmWidth = 7144
              BandType = 1
            end
          end
          object ppDetailBand5: TppDetailBand
            mmBottomOffset = 0
            mmHeight = 6615
            mmPrintPosition = 0
            object ppDBText12: TppDBText
              UserName = 'DBText12'
              Border.BorderPositions = []
              Border.Color = clBlack
              Border.Style = psSolid
              Border.Visible = False
              Border.Weight = 1.000000000000000000
              DataField = 'KarmaKoli'
              DataPipeline = ppDBPipeline4
              Font.Charset = DEFAULT_CHARSET
              Font.Color = clBlack
              Font.Name = 'Arial'
              Font.Size = 10
              Font.Style = []
              ParentDataPipeline = False
              Transparent = True
              DataPipelineName = 'ppDBPipeline4'
              mmHeight = 3969
              mmLeft = 135732
              mmTop = 529
              mmWidth = 36513
              BandType = 4
            end
            object ppDBText13: TppDBText
              UserName = 'DBText13'
              Border.BorderPositions = []
              Border.Color = clBlack
              Border.Style = psSolid
              Border.Visible = False
              Border.Weight = 1.000000000000000000
              DataField = 'miktar'
              DataPipeline = ppDBPipeline4
              Font.Charset = DEFAULT_CHARSET
              Font.Color = clBlack
              Font.Name = 'Arial'
              Font.Size = 10
              Font.Style = []
              ParentDataPipeline = False
              Transparent = True
              DataPipelineName = 'ppDBPipeline4'
              mmHeight = 3969
              mmLeft = 175948
              mmTop = 529
              mmWidth = 17198
              BandType = 4
            end
          end
        end
      end
    end
  end
  object ppekraniyazdir: TppReport
    AutoStop = False
    DataPipeline = ppDBekraniyazdir
    PrinterSetup.BinName = 'Default'
    PrinterSetup.DocumentName = 'Report'
    PrinterSetup.PaperName = 'A4'
    PrinterSetup.PrinterName = 'Default'
    PrinterSetup.mmMarginBottom = 3000
    PrinterSetup.mmMarginLeft = 3000
    PrinterSetup.mmMarginRight = 3000
    PrinterSetup.mmMarginTop = 3000
    PrinterSetup.mmPaperHeight = 297000
    PrinterSetup.mmPaperWidth = 210000
    PrinterSetup.PaperSize = 9
    Units = utMillimeters
    DeviceType = 'Screen'
    EmailSettings.ReportFormat = 'PDF'
    OutlineSettings.CreateNode = False
    OutlineSettings.CreatePageNodes = False
    OutlineSettings.Enabled = False
    OutlineSettings.Visible = False
    PreviewFormSettings.WindowState = wsMaximized
    PreviewFormSettings.ZoomSetting = zs100Percent
    TextSearchSettings.DefaultString = '<FindText>'
    TextSearchSettings.Enabled = True
    Left = 288
    Top = 352
    Version = '10.02'
    mmColumnWidth = 0
    DataPipelineName = 'ppDBekraniyazdir'
    object ppTitleBand2: TppTitleBand
      mmBottomOffset = 0
      mmHeight = 6879
      mmPrintPosition = 0
      object ppLabel10: TppLabel
        UserName = 'Label10'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = #220'retim Oda Listesi'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 12
        Font.Style = [fsBold]
        Transparent = True
        mmHeight = 4995
        mmLeft = 80698
        mmTop = 529
        mmWidth = 37507
        BandType = 1
      end
    end
    object ppHeaderBand2: TppHeaderBand
      mmBottomOffset = 0
      mmHeight = 7408
      mmPrintPosition = 0
      object ppLine2: TppLine
        UserName = 'Line2'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Pen.Color = clNavy
        Pen.Width = 2
        Weight = 1.500000000000000000
        mmHeight = 3969
        mmLeft = 265
        mmTop = 6085
        mmWidth = 201613
        BandType = 0
      end
      object ppLabel11: TppLabel
        UserName = 'Label11'
        AutoSize = False
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Oda'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 10
        Font.Style = []
        Transparent = True
        mmHeight = 4022
        mmLeft = 1323
        mmTop = 1588
        mmWidth = 11377
        BandType = 0
      end
      object ppLabel12: TppLabel
        UserName = 'Label12'
        AutoSize = False
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Stok Kodu'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 10
        Font.Style = []
        Transparent = True
        mmHeight = 4022
        mmLeft = 14023
        mmTop = 1588
        mmWidth = 29633
        BandType = 0
      end
      object ppLabel13: TppLabel
        UserName = 'Label13'
        AutoSize = False
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Adet'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 10
        Font.Style = []
        Transparent = True
        mmHeight = 4022
        mmLeft = 44450
        mmTop = 1588
        mmWidth = 8467
        BandType = 0
      end
      object ppLabel14: TppLabel
        UserName = 'Label14'
        AutoSize = False
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = #304#351'letim Sis.'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 10
        Font.Style = []
        Transparent = True
        mmHeight = 4022
        mmLeft = 53446
        mmTop = 1588
        mmWidth = 40217
        BandType = 0
      end
      object ppLabel15: TppLabel
        UserName = 'Label15'
        AutoSize = False
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'Acil'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 10
        Font.Style = []
        Transparent = True
        mmHeight = 3969
        mmLeft = 93927
        mmTop = 1588
        mmWidth = 6615
        BandType = 0
      end
      object ppLabel17: TppLabel
        UserName = 'Label17'
        AutoSize = False
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'S.P.'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 10
        Font.Style = []
        Transparent = True
        mmHeight = 3969
        mmLeft = 101600
        mmTop = 1588
        mmWidth = 7408
        BandType = 0
      end
      object ppLabel18: TppLabel
        UserName = 'Label18'
        AutoSize = False
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Caption = 'A'#231#305'klama'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'Arial'
        Font.Size = 10
        Font.Style = []
        Transparent = True
        mmHeight = 4022
        mmLeft = 109802
        mmTop = 1588
        mmWidth = 92075
        BandType = 0
      end
    end
    object ppDetailBand2: TppDetailBand
      mmBottomOffset = 0
      mmHeight = 5821
      mmPrintPosition = 0
      object ppDBText1: TppDBText
        UserName = 'DBText1'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'oda'
        DataPipeline = ppDBekraniyazdir
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 8
        Font.Style = []
        TextAlignment = taRightJustified
        Transparent = True
        DataPipelineName = 'ppDBekraniyazdir'
        mmHeight = 3260
        mmLeft = 1323
        mmTop = 529
        mmWidth = 11377
        BandType = 4
      end
      object ppDBText2: TppDBText
        UserName = 'DBText2'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'stokkodu'
        DataPipeline = ppDBekraniyazdir
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppDBekraniyazdir'
        mmHeight = 3260
        mmLeft = 14023
        mmTop = 529
        mmWidth = 29633
        BandType = 4
      end
      object ppDBText3: TppDBText
        UserName = 'DBText3'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'adet'
        DataPipeline = ppDBekraniyazdir
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 8
        Font.Style = []
        TextAlignment = taRightJustified
        Transparent = True
        DataPipelineName = 'ppDBekraniyazdir'
        mmHeight = 3260
        mmLeft = 44450
        mmTop = 529
        mmWidth = 7938
        BandType = 4
      end
      object ppDBText4: TppDBText
        UserName = 'DBText4'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'isletimsistemikodu'
        DataPipeline = ppDBekraniyazdir
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppDBekraniyazdir'
        mmHeight = 3260
        mmLeft = 53446
        mmTop = 529
        mmWidth = 40217
        BandType = 4
      end
      object ppDBText8: TppDBText
        UserName = 'DBText8'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        DataField = 'aciklama'
        DataPipeline = ppDBekraniyazdir
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Name = 'ARIAL'
        Font.Size = 8
        Font.Style = []
        Transparent = True
        DataPipelineName = 'ppDBekraniyazdir'
        mmHeight = 3260
        mmLeft = 109802
        mmTop = 529
        mmWidth = 92075
        BandType = 4
      end
      object myDBCheckBox1: TmyDBCheckBox
        UserName = 'DBCheckBox1'
        CheckBoxColor = clWindowText
        BooleanFalse = 'False'
        BooleanTrue = 'True'
        DataPipeline = ppDBekraniyazdir
        DataField = 'acil'
        Transparent = True
        DataPipelineName = 'ppDBekraniyazdir'
        mmHeight = 5027
        mmLeft = 95250
        mmTop = 0
        mmWidth = 5027
        BandType = 4
      end
      object myDBCheckBox3: TmyDBCheckBox
        UserName = 'DBCheckBox3'
        CheckBoxColor = clWindowText
        BooleanFalse = 'False'
        BooleanTrue = 'True'
        DataPipeline = ppDBekraniyazdir
        DataField = 'speakervarmi'
        Transparent = True
        DataPipelineName = 'ppDBekraniyazdir'
        mmHeight = 5027
        mmLeft = 102394
        mmTop = 0
        mmWidth = 5027
        BandType = 4
      end
      object ppLine20: TppLine
        UserName = 'Line20'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Weight = 0.750000000000000000
        mmHeight = 265
        mmLeft = 265
        mmTop = 4763
        mmWidth = 201877
        BandType = 4
      end
    end
    object ppFooterBand2: TppFooterBand
      mmBottomOffset = 0
      mmHeight = 8996
      mmPrintPosition = 0
      object ppLine19: TppLine
        UserName = 'Line19'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        Pen.Color = clGray
        Pen.Width = 2
        Weight = 1.500000000000000000
        mmHeight = 3175
        mmLeft = 1323
        mmTop = 5821
        mmWidth = 200290
        BandType = 8
      end
      object ppSystemVariable1: TppSystemVariable
        UserName = 'SystemVariable1'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        VarType = vtPrintDateTime
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clNavy
        Font.Name = 'TIMES NEW ROMAN'
        Font.Size = 9
        Font.Style = []
        Transparent = True
        mmHeight = 4498
        mmLeft = 1323
        mmTop = 1323
        mmWidth = 34396
        BandType = 8
      end
      object ppSystemVariable4: TppSystemVariable
        UserName = 'SystemVariable4'
        Border.BorderPositions = []
        Border.Color = clBlack
        Border.Style = psSolid
        Border.Visible = False
        Border.Weight = 1.000000000000000000
        VarType = vtPageNoDesc
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clNavy
        Font.Name = 'TIMES NEW ROMAN'
        Font.Size = 9
        Font.Style = []
        TextAlignment = taRightJustified
        Transparent = True
        mmHeight = 4487
        mmLeft = 178859
        mmTop = 1323
        mmWidth = 17187
        BandType = 8
      end
    end
    object ppSummaryBand2: TppSummaryBand
      PrintHeight = phDynamic
      mmBottomOffset = 0
      mmHeight = 16140
      mmPrintPosition = 0
      object ppSubReport2: TppSubReport
        UserName = 'SubReport2'
        ExpandAll = False
        NewPrintJob = False
        OutlineSettings.CreateNode = True
        TraverseAllData = False
        DataPipelineName = 'ppDBPipeline2'
        mmHeight = 5027
        mmLeft = 0
        mmTop = 265
        mmWidth = 204000
        BandType = 7
        mmBottomOffset = 0
        mmOverFlowOffset = 0
        mmStopPosition = 0
        object ppChildReport2: TppChildReport
          AutoStop = False
          DataPipeline = ppDBPipeline2
          PrinterSetup.BinName = 'Default'
          PrinterSetup.DocumentName = 'Report'
          PrinterSetup.PaperName = 'A4'
          PrinterSetup.PrinterName = 'Default'
          PrinterSetup.mmMarginBottom = 1000
          PrinterSetup.mmMarginLeft = 1000
          PrinterSetup.mmMarginRight = 1000
          PrinterSetup.mmMarginTop = 1000
          PrinterSetup.mmPaperHeight = 297000
          PrinterSetup.mmPaperWidth = 210000
          PrinterSetup.PaperSize = 9
          Units = utMillimeters
          Version = '10.02'
          mmColumnWidth = 0
          DataPipelineName = 'ppDBPipeline2'
          object ppTitleBand4: TppTitleBand
            mmBottomOffset = 0
            mmHeight = 6350
            mmPrintPosition = 0
            object ppLabel21: TppLabel
              UserName = 'Label19'
              Border.BorderPositions = []
              Border.Color = clBlack
              Border.Style = psSolid
              Border.Visible = False
              Border.Weight = 1.000000000000000000
              Caption = #304#351'letim Sistemi'
              Font.Charset = DEFAULT_CHARSET
              Font.Color = clBlack
              Font.Name = 'Arial'
              Font.Size = 10
              Font.Style = []
              Transparent = True
              mmHeight = 3969
              mmLeft = 71967
              mmTop = 1058
              mmWidth = 22754
              BandType = 1
            end
            object ppLabel22: TppLabel
              UserName = 'Label20'
              Border.BorderPositions = []
              Border.Color = clBlack
              Border.Style = psSolid
              Border.Visible = False
              Border.Weight = 1.000000000000000000
              Caption = 'Adet'
              Font.Charset = DEFAULT_CHARSET
              Font.Color = clBlack
              Font.Name = 'Arial'
              Font.Size = 10
              Font.Style = []
              Transparent = True
              mmHeight = 3969
              mmLeft = 114036
              mmTop = 1058
              mmWidth = 7144
              BandType = 1
            end
            object ppLine22: TppLine
              UserName = 'Line21'
              Border.BorderPositions = []
              Border.Color = clBlack
              Border.Style = psSolid
              Border.Visible = False
              Border.Weight = 1.000000000000000000
              Weight = 0.750000000000000000
              mmHeight = 529
              mmLeft = 71173
              mmTop = 5556
              mmWidth = 59267
              BandType = 1
            end
          end
          object ppDetailBand4: TppDetailBand
            mmBottomOffset = 0
            mmHeight = 5027
            mmPrintPosition = 0
            object ppDBText7: TppDBText
              UserName = 'DBText5'
              Border.BorderPositions = []
              Border.Color = clBlack
              Border.Style = psSolid
              Border.Visible = False
              Border.Weight = 1.000000000000000000
              DataField = 'isletimsistemi'
              DataPipeline = ppDBPipeline2
              Font.Charset = DEFAULT_CHARSET
              Font.Color = clBlack
              Font.Name = 'Arial'
              Font.Size = 10
              Font.Style = []
              ParentDataPipeline = False
              Transparent = True
              DataPipelineName = 'ppDBPipeline2'
              mmHeight = 3969
              mmLeft = 71967
              mmTop = 529
              mmWidth = 36513
              BandType = 4
            end
            object ppDBText9: TppDBText
              UserName = 'DBText1'
              Border.BorderPositions = []
              Border.Color = clBlack
              Border.Style = psSolid
              Border.Visible = False
              Border.Weight = 1.000000000000000000
              DataField = 'miktar'
              DataPipeline = ppDBPipeline2
              Font.Charset = DEFAULT_CHARSET
              Font.Color = clBlack
              Font.Name = 'Arial'
              Font.Size = 10
              Font.Style = []
              ParentDataPipeline = False
              Transparent = True
              DataPipelineName = 'ppDBPipeline2'
              mmHeight = 3969
              mmLeft = 114036
              mmTop = 529
              mmWidth = 17198
              BandType = 4
            end
          end
        end
      end
      object ppSubReport3: TppSubReport
        UserName = 'SubReport3'
        ExpandAll = False
        NewPrintJob = False
        OutlineSettings.CreateNode = True
        TraverseAllData = False
        DataPipelineName = 'ppDBPipeline3'
        mmHeight = 5027
        mmLeft = 0
        mmTop = 9260
        mmWidth = 204000
        BandType = 7
        mmBottomOffset = 0
        mmOverFlowOffset = 0
        mmStopPosition = 0
        object ppChildReport3: TppChildReport
          AutoStop = False
          DataPipeline = ppDBPipeline3
          PrinterSetup.BinName = 'Default'
          PrinterSetup.DocumentName = 'Report'
          PrinterSetup.PaperName = 'A4'
          PrinterSetup.PrinterName = 'Default'
          PrinterSetup.mmMarginBottom = 3000
          PrinterSetup.mmMarginLeft = 3000
          PrinterSetup.mmMarginRight = 3000
          PrinterSetup.mmMarginTop = 3000
          PrinterSetup.mmPaperHeight = 297000
          PrinterSetup.mmPaperWidth = 210000
          PrinterSetup.PaperSize = 9
          Units = utMillimeters
          Version = '10.02'
          mmColumnWidth = 0
          DataPipelineName = 'ppDBPipeline3'
          object ppTitleBand6: TppTitleBand
            mmBottomOffset = 0
            mmHeight = 5821
            mmPrintPosition = 0
            object ppLabel16: TppLabel
              UserName = 'Label16'
              Border.BorderPositions = []
              Border.Color = clBlack
              Border.Style = psSolid
              Border.Visible = False
              Border.Weight = 1.000000000000000000
              Caption = 'Karma Koli'
              Font.Charset = DEFAULT_CHARSET
              Font.Color = clBlack
              Font.Name = 'Arial'
              Font.Size = 10
              Font.Style = []
              Transparent = True
              mmHeight = 4022
              mmLeft = 71967
              mmTop = 1058
              mmWidth = 17187
              BandType = 1
            end
            object ppLine10: TppLine
              UserName = 'Line10'
              Border.BorderPositions = []
              Border.Color = clBlack
              Border.Style = psSolid
              Border.Visible = False
              Border.Weight = 1.000000000000000000
              Weight = 0.750000000000000000
              mmHeight = 529
              mmLeft = 71173
              mmTop = 5292
              mmWidth = 59267
              BandType = 1
            end
            object ppLabel23: TppLabel
              UserName = 'Label201'
              Border.BorderPositions = []
              Border.Color = clBlack
              Border.Style = psSolid
              Border.Visible = False
              Border.Weight = 1.000000000000000000
              Caption = 'Adet'
              Font.Charset = DEFAULT_CHARSET
              Font.Color = clBlack
              Font.Name = 'Arial'
              Font.Size = 10
              Font.Style = []
              Transparent = True
              mmHeight = 3969
              mmLeft = 114036
              mmTop = 1058
              mmWidth = 7144
              BandType = 1
            end
          end
          object ppDetailBand6: TppDetailBand
            mmBottomOffset = 0
            mmHeight = 5556
            mmPrintPosition = 0
            object ppDBText10: TppDBText
              UserName = 'DBText10'
              Border.BorderPositions = []
              Border.Color = clBlack
              Border.Style = psSolid
              Border.Visible = False
              Border.Weight = 1.000000000000000000
              DataField = 'KarmaKoli'
              DataPipeline = ppDBPipeline3
              Font.Charset = DEFAULT_CHARSET
              Font.Color = clBlack
              Font.Name = 'Arial'
              Font.Size = 10
              Font.Style = []
              ParentDataPipeline = False
              Transparent = True
              DataPipelineName = 'ppDBPipeline3'
              mmHeight = 3969
              mmLeft = 71967
              mmTop = 529
              mmWidth = 36513
              BandType = 4
            end
            object ppDBText11: TppDBText
              UserName = 'DBText11'
              Border.BorderPositions = []
              Border.Color = clBlack
              Border.Style = psSolid
              Border.Visible = False
              Border.Weight = 1.000000000000000000
              DataField = 'miktar'
              DataPipeline = ppDBPipeline3
              Font.Charset = DEFAULT_CHARSET
              Font.Color = clBlack
              Font.Name = 'Arial'
              Font.Size = 10
              Font.Style = []
              ParentDataPipeline = False
              Transparent = True
              DataPipelineName = 'ppDBPipeline3'
              mmHeight = 3969
              mmLeft = 114036
              mmTop = 529
              mmWidth = 17198
              BandType = 4
            end
          end
        end
      end
    end
  end
  object ppDBekraniyazdir: TppDBPipeline
    DataSource = EmirListesiS
    AutoCreateFields = False
    UserName = 'DBekraniyazdir'
    Left = 256
    Top = 352
    object ppDBekraniyazdirppField1: TppField
      Alignment = taRightJustify
      FieldAlias = 'id'
      FieldName = 'id'
      FieldLength = 0
      DataType = dtInteger
      DisplayWidth = 0
      Position = 0
    end
    object ppDBekraniyazdirppField2: TppField
      Alignment = taRightJustify
      FieldAlias = 'siparisharid'
      FieldName = 'siparisharid'
      FieldLength = 0
      DataType = dtInteger
      DisplayWidth = 10
      Position = 1
    end
    object ppDBekraniyazdirppField3: TppField
      Alignment = taRightJustify
      FieldAlias = 'oda'
      FieldName = 'oda'
      FieldLength = 0
      DataType = dtInteger
      DisplayWidth = 10
      Position = 2
    end
    object ppDBekraniyazdirppField4: TppField
      Alignment = taRightJustify
      FieldAlias = 'stokkod'
      FieldName = 'stokkod'
      FieldLength = 0
      DataType = dtInteger
      DisplayWidth = 10
      Position = 3
    end
    object ppDBekraniyazdirppField5: TppField
      FieldAlias = 'stokkodu'
      FieldName = 'stokkodu'
      FieldLength = 25
      DisplayWidth = 25
      Position = 4
    end
    object ppDBekraniyazdirppField6: TppField
      Alignment = taRightJustify
      FieldAlias = 'adet'
      FieldName = 'adet'
      FieldLength = 0
      DataType = dtInteger
      DisplayWidth = 10
      Position = 5
    end
    object ppDBekraniyazdirppField7: TppField
      Alignment = taRightJustify
      FieldAlias = 'isletimsistemikod'
      FieldName = 'isletimsistemikod'
      FieldLength = 0
      DataType = dtInteger
      DisplayWidth = 10
      Position = 6
    end
    object ppDBekraniyazdirppField8: TppField
      FieldAlias = 'isletimsistemikodu'
      FieldName = 'isletimsistemikodu'
      FieldLength = 25
      DisplayWidth = 25
      Position = 7
    end
    object ppDBekraniyazdirppField9: TppField
      FieldAlias = 'acil'
      FieldName = 'acil'
      FieldLength = 0
      DataType = dtBoolean
      DisplayWidth = 5
      Position = 8
    end
    object ppDBekraniyazdirppField10: TppField
      FieldAlias = 'speakervarmi'
      FieldName = 'speakervarmi'
      FieldLength = 0
      DataType = dtBoolean
      DisplayWidth = 5
      Position = 9
    end
    object ppDBekraniyazdirppField11: TppField
      FieldAlias = 'aciklama'
      FieldName = 'aciklama'
      FieldLength = 200
      DisplayWidth = 200
      Position = 10
    end
    object ppDBekraniyazdirppField12: TppField
      Alignment = taRightJustify
      FieldAlias = 'geciciuremriid'
      FieldName = 'geciciuremriid'
      FieldLength = 0
      DataType = dtInteger
      DisplayWidth = 10
      Position = 11
    end
  end
  object EmirlistesiAktarildiYapoda1: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    Parameters = <
      item
        Name = 'emirno'
        Attributes = [paSigned, paNullable]
        DataType = ftInteger
        Precision = 10
        Size = 4
        Value = Null
      end
      item
        Name = 'stokkod'
        Attributes = [paSigned, paNullable]
        DataType = ftInteger
        Precision = 10
        Size = 4
        Value = Null
      end
      item
        Name = 'isletimsistemikod'
        Attributes = [paSigned, paNullable]
        DataType = ftInteger
        Precision = 10
        Size = 4
        Value = Null
      end
      item
        Name = 'grupkodu'
        Attributes = [paNullable]
        DataType = ftString
        NumericScale = 255
        Precision = 255
        Size = 50
        Value = Null
      end
      item
        Name = 'KarmaKoliKod'
        Attributes = [paSigned, paNullable]
        DataType = ftInteger
        Precision = 10
        Size = 4
        Value = Null
      end>
    SQL.Strings = (
      'update Unity_Emirlistesi'
      'set aktarilanuremrino=:emirno'
      
        'where oda=1 and aktarilanuremrino is null and stokkod=:stokkod a' +
        'nd isletimsistemikod=:isletimsistemikod and grupkodu=:grupkodu'
      'and KarmaKoliKod=:KarmaKoliKod')
    Left = 447
    Top = 320
  end
  object EmirlistesiAktarildiYapoda2: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    Parameters = <
      item
        Name = 'emirno'
        Attributes = [paSigned, paNullable]
        DataType = ftInteger
        Precision = 10
        Size = 4
        Value = Null
      end
      item
        Name = 'id'
        Attributes = [paSigned]
        DataType = ftInteger
        Precision = 5
        Size = 2
        Value = Null
      end>
    SQL.Strings = (
      'update Unity_Emirlistesi'
      'set aktarilanuremrino=:emirno'
      'where id=:id')
    Left = 464
    Top = 248
  end
  object isletimsistemitoplamiQ: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    Parameters = <>
    SQL.Strings = (
      
        'select miktar,isletimsistemi=(case when isnull(isletimsistemsiz,' +
        #39#39')='#39#39' then (select (select stokkodu from stok where stok.stokko' +
        'd=Uremrihar.stokkod) from uremrihar where uremrihar.emirno=Uremr' +
        'i.emirno and (select marka from stok where stok.stokkod=Uremriha' +
        'r.stokkod) in (219,839)) else '#39'Lisanss'#305'z'#39' end)   into #isletimsi' +
        'temi'
      
        'from Unity_Liste,Uremri where (yazdirildi is null) and Uremri.em' +
        'irno=Unity_Liste.emirno'
      ''
      'select isletimsistemi,sum(miktar) as miktar from #isletimsitemi'
      'group by isletimsistemi'
      ''
      'drop table #isletimsitemi'
      '')
    Left = 144
    Top = 288
  end
  object isletimsistemitoplamiS: TDataSource
    DataSet = isletimsistemitoplamiQ
    Left = 40
    Top = 288
  end
  object ppDBPipeline2: TppDBPipeline
    DataSource = isletimsistemitoplamiS
    AutoCreateFields = False
    UserName = 'DBPipeline2'
    Left = 256
    Top = 304
    object ppDBPipeline2ppField1: TppField
      FieldAlias = 'isletimsistemi'
      FieldName = 'isletimsistemi'
      FieldLength = 0
      DisplayWidth = 0
      Position = 0
    end
    object ppDBPipeline2ppField2: TppField
      Alignment = taRightJustify
      FieldAlias = 'miktar'
      FieldName = 'miktar'
      FieldLength = 0
      DataType = dtInteger
      DisplayWidth = 10
      Position = 1
    end
  end
  object StokKodBulQ: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    Parameters = <
      item
        Name = 'stokkod'
        Attributes = [paSigned]
        DataType = ftInteger
        Precision = 10
        Size = 4
        Value = Null
      end>
    SQL.Strings = (
      'select stokkod,stokkodu,cinsi,mamultipi,'
      
        '(Case When isnull(GrupKodu,'#39#39')='#39'Karma'#39' Then 6 Else isnull(UnityC' +
        'ardType,0) end)  UnityCardType'
      'from stok where stokkod=:stokkod')
    Left = 496
    Top = 136
  end
  object EkParcalarQ: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    Parameters = <
      item
        Name = 'stokkod'
        Size = -1
        Value = Null
      end
      item
        Name = 'isletimsistemikod'
        Size = -1
        Value = Null
      end
      item
        Name = 'grupkodu'
        Size = -1
        Value = Null
      end>
    SQL.Strings = (
      'Select stokkod from Unity_EmirListesi_EkParca '
      
        'where Unity_EmirListesi_EkParca.emirlistesiid=(select max(id) fr' +
        'om Unity_EmirListesi u where oda=1 and aktarilanuremrino is null' +
        ' and u.stokkod=:stokkod and u.isletimsistemikod=:isletimsistemik' +
        'od and u.grupkodu=:grupkodu)')
    Left = 528
    Top = 80
  end
  object SonListeNoBulQ: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select Uremri.emirno,stokkodu,cinsi,miktar,aciklama,'
      
        '       isletimsistemi=(case when isnull(isletimsistemsiz,'#39#39')='#39#39' ' +
        'then (select (select stokkodu from stok where stok.stokkod=Uremr' +
        'ihar.stokkod) from uremrihar where uremrihar.emirno=Uremri.emirn' +
        'o and (select marka from stok where stok.stokkod=Uremrihar.stokk' +
        'od) in (219,839)) else '#39'Lisanss'#305'z'#39' end),'
      
        '      depo=(select depoadi from depolar where id=Uremri.ciktidep' +
        'o)   '
      'from Unity_Liste,Uremri'
      'where (yazdirildi is null) and Uremri.emirno=Unity_Liste.emirno'
      'order by Uremri.emirno'
      '')
    Left = 448
    Top = 184
  end
  object ExtraOptions1: TExtraOptions
    About = 'TExtraDevices 3.00'
    HTML.ItemsToExport = [reText, reImage, reLine, reShape, reRTF, reBarCode, reCheckBox]
    HTML.BackLink = '&lt&lt'
    HTML.ForwardLink = '&gt&gt'
    HTML.ShowLinks = True
    HTML.UseTextFileName = False
    HTML.ZoomableImages = False
    HTML.Visible = True
    HTML.PixelFormat = pf8bit
    HTML.SingleFileOutput = False
    XHTML.ItemsToExport = [reText, reImage, reLine, reShape, reRTF, reBarCode, reCheckBox]
    XHTML.BackLink = '&lt&lt'
    XHTML.ForwardLink = '&gt&gt'
    XHTML.ShowLinks = True
    XHTML.UseTextFileName = False
    XHTML.ZoomableImages = False
    XHTML.Visible = True
    XHTML.PixelFormat = pf8bit
    XHTML.SingleFileOutput = False
    RTF.ItemsToExport = [reText, reImage, reLine, reShape, reRTF, reBarCode, reCheckBox]
    RTF.Visible = True
    RTF.RichTextAsImage = False
    RTF.UseTextBox = True
    RTF.PixelFormat = pf8bit
    RTF.PixelsPerInch = 96
    Lotus.ItemsToExport = [reText, reImage, reLine, reShape, reRTF, reBarCode, reCheckBox]
    Lotus.Visible = True
    Lotus.ColSpacing = 16934
    Quattro.ItemsToExport = [reText, reImage, reLine, reShape, reRTF, reBarCode, reCheckBox]
    Quattro.Visible = True
    Quattro.ColSpacing = 16934
    Excel.ItemsToExport = [reText, reImage, reLine, reShape, reRTF, reBarCode, reCheckBox]
    Excel.Visible = True
    Excel.ColSpacing = 16934
    Excel.RowSizing = False
    Excel.AutoConvertToNumber = True
    Graphic.ItemsToExport = [reText, reImage, reLine, reShape, reRTF, reBarCode, reCheckBox]
    Graphic.PixelFormat = pf8bit
    Graphic.UseTextFileName = False
    Graphic.Visible = True
    Graphic.PixelsPerInch = 96
    Graphic.GrayScale = False
    PDF.ItemsToExport = [reText, reImage, reLine, reShape, reRTF, reBarCode, reCheckBox]
    PDF.FastCompression = False
    PDF.CompressImages = True
    PDF.ScaleImages = True
    PDF.Visible = True
    PDF.RichTextAsImage = False
    PDF.RichEditPixelFormat = pf1bit
    PDF.PixelFormat = pf24bit
    PDF.PixelsPerInch = 96
    PDF.Permissions = [ppPrint, ppModify, ppCopy, ppModifyAnnot]
    PDF.ViewerPreferences = []
    PDF.AutoEmbedFonts = True
    PDF.ImageFormat = riBitmap
    DotMatrix.ItemsToExport = [reText, reImage, reLine, reShape, reRTF, reBarCode, reCheckBox]
    DotMatrix.Visible = True
    DotMatrix.CharsPerInch = cs10CPI
    DotMatrix.LinesPerInch = ls6LPI
    DotMatrix.Port = 'LPT1'
    DotMatrix.ContinousPaper = False
    DotMatrix.PrinterType = ptEpson
    Left = 294
    Top = 415
  end
  object aqKarmaZPaketBul: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    Parameters = <
      item
        Name = 'AnaStokkod'
        Attributes = [paSigned]
        DataType = ftInteger
        Precision = 10
        Size = 4
        Value = Null
      end>
    SQL.Strings = (
      
        'select *,dbo.GetStokkodu(KStokkod) Stokkodu,dbo.GetCinsi(KStokko' +
        'd) Cinsi from TblStokKarmaZPaket Where AnaStokkod=:AnaStokkod')
    Left = 578
    Top = 135
  end
  object adoTur: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select * from TblSiparisTur order by sira')
    Left = 563
    Top = 203
  end
  object EmirlistesiKontrolYapoda1: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    Parameters = <
      item
        Name = 'stokkod'
        Attributes = [paSigned, paNullable]
        DataType = ftInteger
        Precision = 10
        Size = 4
        Value = Null
      end
      item
        Name = 'isletimsistemikod'
        Attributes = [paSigned, paNullable]
        DataType = ftInteger
        Precision = 10
        Size = 4
        Value = Null
      end
      item
        Name = 'grupkodu'
        Attributes = [paNullable]
        DataType = ftString
        NumericScale = 255
        Precision = 255
        Size = 50
        Value = Null
      end
      item
        Name = 'KarmaKoliKod'
        Attributes = [paSigned, paNullable]
        DataType = ftInteger
        Precision = 10
        Size = 4
        Value = Null
      end>
    SQL.Strings = (
      'Select S.Carikod,S.SiparisNo,Sh.Stokkod'
      'from Unity_Emirlistesi UE '
      'Left Join Unity_Siparishar_2006 Sh on (UE.Siparisharid=Sh.id)'
      'Left Join Unity_Siparis_2006 S on (S.id=Sh.Siparisid)'
      
        'where UE.oda=1 and UE.aktarilanuremrino is null and UE.stokkod=:' +
        'stokkod and UE.isletimsistemikod=:isletimsistemikod and UE.grupk' +
        'odu=:grupkodu'
      'and UE.KarmaKoliKod=:KarmaKoliKod')
    Left = 447
    Top = 379
  end
  object PixelKontrol: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    Parameters = <
      item
        Name = 'Carikod'
        Attributes = [paSigned, paNullable]
        DataType = ftInteger
        Precision = 10
        Size = 4
        Value = Null
      end
      item
        Name = 'SiparisNo'
        Attributes = [paNullable]
        DataType = ftString
        NumericScale = 255
        Precision = 255
        Size = 9
        Value = Null
      end
      item
        Name = 'stokkod'
        Attributes = [paSigned, paNullable]
        DataType = ftInteger
        Precision = 10
        Size = 4
        Value = Null
      end>
    SQL.Strings = (
      'Select Carikod,SiparisNo,Stokkod '
      'From TblAnlasma An WITH(NOLOCK)'
      'left Join TblAnlasmahar Anh on (An.Ref=Anh.AnlasmaRef)'
      'Where An.Aktif=1 and An.Tipi=1 and'
      '(Getdate()>=An.BasTarih and Getdate()<=An.BitTarih)'
      'and (Carikod is null or Carikod=:Carikod)'
      'and (SiparisNo is null or SiparisNo=:SiparisNo)'
      'and (Stokkod is null or Stokkod=:Stokkod)')
    Left = 552
    Top = 379
  end
  object ppDBPipeline3: TppDBPipeline
    DataSource = dsKarmaKoliToplam
    AutoCreateFields = False
    UserName = 'DBPipeline3'
    Left = 305
    Top = 306
    object ppField1: TppField
      FieldAlias = 'isletimsistemi'
      FieldName = 'isletimsistemi'
      FieldLength = 0
      DisplayWidth = 0
      Position = 0
    end
    object ppField2: TppField
      Alignment = taRightJustify
      FieldAlias = 'miktar'
      FieldName = 'miktar'
      FieldLength = 0
      DataType = dtInteger
      DisplayWidth = 10
      Position = 1
    end
  end
  object aqKarmaKoliToplam: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    Parameters = <
      item
        Name = 'UstGrupId1'
        DataType = ftString
        Size = 10
        Value = Null
      end
      item
        Name = 'GrupId1'
        DataType = ftString
        Size = 10
        Value = Null
      end
      item
        Name = 'ModelId1'
        DataType = ftString
        Size = 10
        Value = Null
      end
      item
        Name = 'UstGrupId2'
        DataType = ftString
        Size = 10
        Value = Null
      end
      item
        Name = 'GrupId2'
        DataType = ftString
        Size = 10
        Value = Null
      end
      item
        Name = 'ModelId2'
        DataType = ftString
        Size = 10
        Value = Null
      end>
    SQL.Strings = (
      'select '
      
        '       KarmaKoli=(case KarmaKoliKod when 0 then '#39'Karma Kolisiz'#39' ' +
        'else (select stokkodu from stok where stok.stokkod=Unity_EmirLis' +
        'tesi. KarmaKoliKod) end), '
      '       sum(adet) as Miktar'
      'into #KarmaKoli'
      'from Unity_Emirlistesi'
      
        'where oda=1 and aktarilanuremrino is null and stokkod in (select' +
        ' stokkod from stok where stok.UstGrupId like :UstGrupId1 and sto' +
        'k.GrupId like :GrupId1 and stok.ModelId like :ModelId1)'
      'group by  KarmaKoliKod'
      'insert into #KarmaKoli (KarmaKoli,Miktar)'
      'select '
      
        '       KarmaKoli=(case KarmaKoliKod when 0 then '#39'Karma Kolisiz'#39' ' +
        'else (select stokkodu from stok where stok.stokkod=Unity_EmirLis' +
        'tesi. KarmaKoliKod) end), '
      '       Miktar=adet'
      'from Unity_Emirlistesi'
      
        'where oda=2 and aktarilanuremrino is null and stokkod in (select' +
        ' stokkod from stok where  stok.UstGrupId like :UstGrupId2 and st' +
        'ok.GrupId like :GrupId2 and stok.ModelId like :ModelId2)'
      
        'Select KarmaKoli,Miktar=Sum(Miktar) From #KarmaKoli Group By Kar' +
        'maKoli order by KarmaKoli'
      'Drop Table #KarmaKoli')
    Left = 147
    Top = 370
  end
  object dsKarmaKoliToplam: TDataSource
    DataSet = aqKarmaKoliToplam
    Left = 43
    Top = 370
  end
  object aqKarmaKoliToplam2: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    Parameters = <
      item
        Name = 'UstGrupId1'
        DataType = ftString
        Size = 10
        Value = Null
      end
      item
        Name = 'GrupId1'
        DataType = ftString
        Size = 10
        Value = Null
      end
      item
        Name = 'ModelId1'
        DataType = ftString
        Size = 10
        Value = Null
      end
      item
        Name = 'UstGrupId2'
        DataType = ftString
        Size = 10
        Value = Null
      end
      item
        Name = 'GrupId2'
        DataType = ftString
        Size = 10
        Value = Null
      end
      item
        Name = 'ModelId2'
        DataType = ftString
        Size = 10
        Value = Null
      end>
    SQL.Strings = (
      'select '
      
        '       KarmaKoli=(case KarmaKoliKod when 0 then '#39'Karma Kolisiz'#39' ' +
        'else (select stokkodu from stok where stok.stokkod=Unity_EmirLis' +
        'tesi. KarmaKoliKod) end), '
      '       sum(adet) as Miktar'
      'into #KarmaKoli'
      'from Unity_Emirlistesi'
      
        'where oda=1 and aktarilanuremrino is null and stokkod in (select' +
        ' stokkod from stok where stok.UstGrupId like :UstGrupId1 and sto' +
        'k.GrupId like :GrupId1 and stok.ModelId like :ModelId1)'
      'group by  KarmaKoliKod'
      'insert into #KarmaKoli (KarmaKoli,Miktar)'
      'select '
      
        '       KarmaKoli=(case KarmaKoliKod when 0 then '#39'Karma Kolisiz'#39' ' +
        'else (select stokkodu from stok where stok.stokkod=Unity_EmirLis' +
        'tesi. KarmaKoliKod) end), '
      '       Miktar=adet'
      'from Unity_Emirlistesi'
      
        'where oda=2 and aktarilanuremrino is null and stokkod in (select' +
        ' stokkod from stok where  stok.UstGrupId like :UstGrupId2 and st' +
        'ok.GrupId like :GrupId2 and stok.ModelId like :ModelId2)'
      
        'Select KarmaKoli,Miktar=Sum(Miktar) From #KarmaKoli Group By Kar' +
        'maKoli order by KarmaKoli'
      'Drop Table #KarmaKoli')
    Left = 143
    Top = 429
  end
  object dsKarmaKoliToplam2: TDataSource
    DataSet = aqKarmaKoliToplam2
    Left = 39
    Top = 429
  end
  object ppDBPipeline4: TppDBPipeline
    DataSource = dsKarmaKoliToplam2
    AutoCreateFields = False
    UserName = 'DBPipeline4'
    Left = 367
    Top = 239
    object ppField3: TppField
      FieldAlias = 'isletimsistemi'
      FieldName = 'isletimsistemi'
      FieldLength = 0
      DisplayWidth = 0
      Position = 0
    end
    object ppField4: TppField
      Alignment = taRightJustify
      FieldAlias = 'miktar'
      FieldName = 'miktar'
      FieldLength = 0
      DataType = dtInteger
      DisplayWidth = 10
      Position = 1
    end
  end
end
